﻿CREATE TABLE [dbo].[ProductBaseInfo] (
    [ProductBaseID]   BIGINT           IDENTITY (1, 1) NOT NULL,
    [ProductCategory] TINYINT          NULL,
    [ProductName]     NVARCHAR (200)   NULL,
    [ImageID]         UNIQUEIDENTIFIER NULL,
    [SendCargoID]     INT              NULL,
    [ProductProperty] TINYINT          NULL,
    [BuyLeast]        INT              NULL,
    [BuyCardinality]  INT              NULL,
    [Unit]            NVARCHAR (10)    NULL,
    [BuyExplain]      TINYINT          NULL,
    [Rate]            DECIMAL (8, 4)   NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'辅料比例', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'Rate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'购买说明', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'BuyExplain';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'单位', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'Unit';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'购买基数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'BuyCardinality';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'最小购买数量', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'BuyLeast';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'性质', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'ProductProperty';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'发货地标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'SendCargoID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'默认图标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'ImageID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'商品名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'ProductName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'商品种类', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'ProductCategory';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'商品基本信息标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo', @level2type = N'COLUMN', @level2name = N'ProductBaseID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'商品基本信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductBaseInfo';

